Micron Document


Search Archives | Info


Window function (SQL)
part 4/6 · 11.3 KB total
◀ Prev · Parts · Full · Next ▶
──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
The result query contains the following values:

| PREV | NAME | NEXT |
|----------|----------|----------|
| (null)| Aaron| Andrew|
| Aaron| Andrew| Amelia|
| Andrew| Amelia| James|
| Amelia| James| Jill|
| James| Jill| Johnny|
| Jill| Johnny| Michael|
| Johnny| Michael| Nick|
| Michael| Nick| Ophelia|
| Nick| Ophelia| Zach|
| Ophelia| Zach| (null)|

History

Window functions were incorporated into the SQL:2003 standard and had functionality expanded in later specifications.cite-ref-11[11]

Support for particular database implementations was added as follows:

• Oracle - version 8.1.6 in 2000.cite-ref-12[12]cite-ref-13[13]
• PostgreSQL - version 8.4 in 2009.cite-ref-14[14]
• MySQL - version 8 in 2018.cite-ref-15[15]cite-ref-16[16]
• MariaDB - version 10.2 in 2016.cite-ref-17[17]
• SQLite - release 3.25.0 in 2018.cite-ref-18[18]

──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
◀ Prev · Parts · Full · Next ▶